﻿CREATE TABLE [dbo].[FloatData]
(
	[DataId] bigint NOT NULL IDENTITY(1,1),
	[Time] DATETIME2 NOT NULL, 
    [Value] FLOAT NULL,
	[LeftDeviation] FLOAT NULL,
    [TagId] BIGINT NOT NULL, 
    [Flag] TINYINT NOT NULL DEFAULT 0, 
    CONSTRAINT [PK_FloatData] PRIMARY KEY ([TagId], [Time])
)

GO

CREATE INDEX [IX_FloatData_DataId] ON [dbo].[FloatData] ([DataId])
